package com.hooware.dao;

import com.hooware.domain.Orders;
import com.hooware.domain.Traveller;
import org.apache.ibatis.annotations.One;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

public interface ITravellerDao {

    /**
     * 根据id查询orders
     * @param id
     * @return
     */
    @Select("select * from traveller where id in (select ot.travellerid from order_traveller ot where ot.orderid = #{id})")
    Traveller findById(String id);
}
